from types import coroutine
import mysql.connector
conn=mysql.connector.connect(user="root",password="",database="yangqing")
cursor = conn.cursor()
cursor.execute("create table lesson(\
    id varchar(20) PRIMARY KEY, \
    name varchar(20)) ")
cursor.close()
conn.close()    












# import mysql.connector
# conn = mysql.connector.connect(user='root', password='password', database='lilizong')
# cursor = conn.cursor()
# cursor.execute('create table lesson (\
#     ID varchar(20) primary key, \
#     name varchar(20))')
# cursor.close()
# conn.close()·